APCLOSE

PFR0029

Monthly

Close A/P Accounting Period

Updates the Accounting Period table with a close date. Also, prevents back dating transactions, since you cannot post to a closed period.

Run A/P reports before executing this periodic function.

APJRDT

PFR0003

Monthly

Purchase Journal Summary by Date

See A/P Purchases Summary Report by Invoice Posted Date.

APJRGL

PFR0015*

Monthly

Purchase Journal Summary by G/L Number

See Purchase Journal Summary Report by Vendor Number.

APJRVN

PFR0018

Monthly

Purchase Journal Summary by Vendor

See Purchase Journal Summary Report by Vendor Number.

APLEDG

PFR0035

Monthly

A/P Ledger for Held/Open Invoices

Generates the A/P Ledger.

APLEDGR

PFR0001

Monthly

A/P Ledger

Generates the A/P Ledger.

DSJRDT

PFR0004

Monthly

Disbursement Journal Summary by Date

Generates the Disbursements Journal Summary Report by Check Printed Date.

DSJRGL

PFR0016

Monthly

Disbursement Journal Summary by G/L Number

Generates the Disbursements Journal Summary Report by Vendor Number.

DSJRVN

PFR0017

Monthly

Disbursement Journal Summary by Vendor

Generates the Disbursements Journal Summary Report by Vendor Number.

GIFTISS

PFR0010

Monthly

Issued Gift Certificates

Generates the Unredeemed Gift Certificate List, which lists all gift certificates that have not been fully redeemed (used as payment) on a shipped order. Recently redeemed gift certificates remain on this report until the orders where they are redeemed are billed.

See Print Unredeemed Gift Certificate Screen (PUGC) and Working with Gift Certificates.

GLRESET

PFR0117

General Ledger Reset

Runs the general ledger reset program to clear the General Ledger Interface table and recreate postings based on updated or corrected information. See Resetting the General Ledger Interface Table (RGLI) for background.

• Runs for the prior date

• Uses the division from the A/P Invoice Upload Division (H70)

• Uses the bank from the A/P Invoice Upload Bank (H71)

Note: If either of the above system control values is blank, the function writes an error to the APP.log file. See Logs for more information.

ARCLOSE

PFR0028

Monthly

Close A/R Accounting Period

Updates the Accounting Period table with a close date. Also, prevents back dating transactions, since you cannot post to a closed period.

Run A/R reports before executing this periodic function.

ARCNDAY

PFR0025

Daily

Daily A/R Control

Generates the A/R Control Report.

ARCNMON

PFR0026

Monthly

Monthly A/R Control

Generates the A/R Control Report.

AVGDPAY

ACR0108

Monthly

Average Days to Pay

Average days to pay; the number of days between the invoice date and the date payment for the invoice is posted to the customer’s A/R account.

Updates the CBT Average days to pay field in the Customer Bill To table.

See Using A/R Inquiry (DARI).

CBTAGE

ACR0121

Monthly

Customer Bill To Aging

Updates the CBT Aging field in the Customer Bill To table.

See the A/R Aging Summary Report (Condensed).

CBTAGER

PFR0022

Monthly

A/R Aging Reports

Generates the Processed Refund Register.

CBTCYTD

ACR0123

Yearly

Move and Clear YTD Buckets

Clears any YTD (year-to-date) buckets

Tables affected include Customer Bill To, Flash Report, Item Warehouse, and Location.

CR_ME

PFR0002

Monthly

Month End Cash Receipts Journal

Generates the Monthly Cash Receipts Journal.

RSOORBT

OER0951

Monthly

Update On-Order in CBT

Updates the CBT $ on order field in the Customer Bill To table.

AUTHALL

PFR0131

As needed

Authorize All Open Orders

Calls Performing Batch Authorization (SATH), which processes online authorizations for all open orders that contain a credit card or stored value card payment that requires authorization.

This periodic function allows you to use the job scheduler to schedule when you wish to process the Batch Authorization Program (SATH).

BO_REAS

PFR0024

Daily

Evaluate Backorder Reasons without Backorder Warehouse

Tries to reserve order detail lines that have a backorder reason, but no backorder warehouse. If inventory is not available, this function assigns a backorder warehouse so that the order detail line will process through Evaluate Backorders. See Working with the EBO_ASYNC Job.

If an order line on backorder is reserved, the system determines whether the order line is eligible for pick slip preparation; see Preparing Orders for Pick Slip Generation.

BROKER

PFR0083

As needed

Generate Order Broker Requests

Generates Order Broker requests for currently eligible orders that have not previously been submitted to the Order Broker. You might use this function when you are first starting to use the Order Broker integration, or on a periodic basis to generate requests for backordered lines that were not previously eligible because, for instance, the order was held. See the Order Broker Integration for an overview.

CASHRP

ACR0273

Daily

Cash Receipts Journal

Prints the Daily Cash Receipts Journal.

Note: The Multi Currency by Offer (E03) system control value must be unselected to execute this periodic function.

CLR_MTH

MSR0576

Monthly

Monthly Clear Process

Clears (updates the zero) the MTD (month-to-date) fields in all tables.

Tables affected include Picker Error History, Picker/Packer, Flash Report, Item Warehouse, Location, Picker Error History.

DBST

ACR0178

Daily

Daily Business Status Report

Generates the Daily Business Status report for the day, which provides a high-level summary of sales, cash, inventory, A/R and A/P aging, order activity and shipments.

See A/R Printing Functions.

DLTACPR

PFR0121

Number of hours

The system deletes all active procedures for interactive jobs that are older than the number of hours defined.

If you do not define a number of hours, the default number of hours is 24.

Daily

Delete Stranded Active Procedures

Deletes active procedures for interactive jobs that are older than the number of hours defined in the Parameter field. If you leave the Parameter field blank, the system deletes active procedures for interactive jobs that are older than 24 hours.

Which interactive jobs? When you run this periodic function, the system checks the Active Procedures table to see if there are any active records for the following applications:

• Order Entry/Maintenance

• Purchase Order Entry/Maintenance

• Receiving

• Confirmation

• PC Manifest or the Generic Pick In API (Shipments, Voids, and Backorders)

The system compares the Date and Time in the Active Procedure table against the date and time when you run this periodic function to determine which active procedure records for interactive jobs to delete.

Note: Do not run this periodic function while users are still using the applications listed above. If you delete Active Procedures records while a user is still in the application, the user job will not be ended; that user can still enter transactions in the application, but transaction records cannot be sent to the data queues for processing because the data queues are reorganized when the ASYNC jobs end. No back end table updates for that user's transactions will be posted, which will cause your data tables to be out of sync.

DLYCLR

MSR0574

Daily

Clear Daily Journals

• Clears (updates to 0) all daily buckets.

• Clears (updates to 0) the TD (today) fields in all tables.

Tables affected include Flash Report, Division, Item Warehouse, Order Type/User, Picker/Packer, Ship Via.

You should run daily reports before executing this periodic function.

Add this function as the last one (or just before reorganizing data tables) in a daily periodic process.

DSHPROC

FLRDSHP

Daily

Process Drop Ship Orders

Processes all drop ship orders by vendor, and generates vendor drop ship worksheet, purchase orders and invoices, or pick slips. Output depends on the Drop ship output selection in the Second Create Vendor Screen.

.

You can also submit this process on demand at the Select Vendors for Drop Ship Screen.

DSLJPAY

ACR0315

Daily

Daily Sales Journal by Pay Type

Generates the Daily Sales Journal by Pay Type.

See Order Status and Activity Reports.

DSLJRN

ACR0216

Daily

Daily Sales Journal

Generates the Daily Sales Journal.

See Order Status and Activity Reports.

DWCHG

DWR0068

Daily

Process Data Warehouse Changes

Builds records in each related DW Staging table based on the key in the DW Transaction table.

You can also submit this process on demand at the Process Data Warehouse Changes Window.

Note: The Use Data Warehouse (G94) system control value must be selected.

See Working with the Data Warehouse Integration in CWSerenade.

ECOMERR

ECR0295

Daily

Batch OM Transaction Error Listing

Generates the E-Commerce Order Maintenance Errors Report.

See Working with Batch Order Maintenance Transactions (WBOM).

ECOMMCH

PFORDXCHK

Daily

Compares the records in the E-Commerce Order Comparison table with the records in the Order Header, Order Header Extended, and Deleted Order tables to determine whether each order in the E-Commerce Order Comparison table is accounted for, and generates a report listing the results. See Running the E-Commerce Order Comparison Program for more information.

ENDASYN

MSENDASYNC

Daily

End Asyncs

If the asyncs are currently Active, this periodic function calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control (MBJC) and ends the background jobs.

This periodic function performs the same updates as selecting End for the controlling data queue to end the background jobs; however, any records in the data queue will be processed when the background ASYNC jobs are restarted. See Ending the Background ASYNC Jobs for more information on the updates that are performed.

ENDIJCT

ILENDGENER

The Process ID for the integration layer process you wish to end.

As needed

End IJCT Process Passed

Ends the integration layer process whose Process ID is defined in the Parameter field.

Example: If you define ITEM_OUT in the Parameter field, this periodic function ends the ITEM_OUT integration layer process.

FTPENCR

PPR0012

Run this periodic function only if the passwords in WFTP are NOT encrypted.

Encrypt FTP

Encrypts all passwords in the Work with FTP Application (WFTP) menu option.

Note:

• This periodic function is delivered and assigned to periodic process ENCFTP.

• Before running this periodic function, you must make sure the passwords in WFTP are not already encrypted; if they are already encrypted, do NOT run this periodic function.

• To correctly encrypt existing passwords in the Work with FTP Application (WFTP) menu option, run this periodic function before advancing to the Work with FTP Application (WFTP) menu option. If you run this periodic function after a user creates or changes passwords, these passwords will be double encrypted; in this situation, you must change the password again after running the periodic function.

• Because they are encrypted, passwords display in the Work with FTP Application (WFTP) menu option as asterisks (******).

FUTURE

FLR0246

Daily

Evaluate Future Orders

Evaluates and reserves orders. If the arrival date - lead days = today’s date, then the system reserves the stock and updates the Future order flag to N.

If the order is reserved and updated to an open status, the system determines whether the order is eligible for pick slip preparation; see Preparing Orders for Pick Slip Generation.

MDADRCG

CSX1069

Daily

Marketing Download Address Change Report

Generates the Marketing Download Change of Address Interface Report when you submit a periodic process that also includes the Marketing Download Extract.

MDCSCHG

CSX1061

Daily

Marketing Download Customer Status Change Report

Generates the Marketing Download Customer Status Change Interface Report when you submit a periodic process that also includes the Marketing Download Extract.

MDEXTR

CSX1041

Daily

Marketing Download Extract

Extracts information from the Marketing Download Trigger table and populates the Marketing Download order-related and customer-related tables, based on the setting of the Populate Marketing Download Trigger File (G33) system control value. Once populated, deletes the associated records in the Marketing Download Trigger table.

See Working with the Marketing Download Extract.

MDEXPRT

PFR0130

Daily

Marketing Download Export

Exports the data in the Marketing Download order-related and customer-related tables to pipe-delimited files and places the files in the Marketing folder of the directory defined in the CWDIRECTCP_ FTP_FOLDER property. Once the extract files are created, the system deletes the records in the associated Marketing Download tables.

See Working with the Marketing Download Extract.

MDINQSM

CSX1066

Daily

Marketing Download Inquiry Summary Report

Generates the Marketing Download Customer Inquiry Interface Report when you submit a periodic process that also includes the Marketing Download Extract.

MDORDHD

CSX1044

Daily

Marketing Download Order Header Report

Generates the Marketing Download Order Header Interface Summary Report when you submit a periodic process that also includes the Marketing Download Extract.

MDORDTL

CSX1058

Daily

Marketing Download Order Detail Change Report

Generates the Marketing Download Order Detail Interface Summary Report when you submit a periodic process that also includes the Marketing Download Extract.

MDSRC

CSR1033

Daily

Marketing Download Source Extract

Populates the Marketing Download Source Download table, based on the records in the Source Code table. See Working with the Marketing Download Extract.

MDSRCSM

CSX1036

Daily

Marketing Download Source Summary Report

Generates the Marketing Download Source Code Interface Summary Report when you submit a periodic process that also includes the Marketing Download Source Extract.

MDVND

CSR1038

Daily

Marketing Download Vendor Extract

Populates the Marketing Download Vendor Download table, based on the records in the Vendor table whose User 1 field contains the text ACTIVE. See Working with the Marketing Download Extract.

ONHAND

PFR0005

Monthly

On Hand by Warehouse

Generates the On Hand by Warehouse Report.

See Working with Interactive Reservation (MIRV).

ORDSUM

PFR0062

Daily

Order Summary

• Updates all of the fields defined in the Order Control Summary table for the current transaction date. See Reviewing Operations Control Summary (FLSH).

• Updates the actual value fields and Last updated fields defined in the Threshold Values table. See Working with Threshold Values (WTHR).

• Generates the Operations Control Report.

Note: This periodic function performs updates similar to the THRESHD periodic function.

PFSDOUT

CSSDOUT

Daily

Sold Out Processing

Generates the soldout notifications.

.You can also submit this process on demand through the Generating Soldout Notifications (MSON).

POLAYER

PFR0092

Daily

Update PO Layering CPOL

Updates the expected delivery dates for items on backorder based on the records that currently exist in the PO Layering table. You would use this screen if you use an external system to create purchase orders and upload this information to the PO Layering table in CWSerenade. The periodic function performs Update PO Layering (CPOL) for all allocatable warehouses in the company you specify. See Update PO Layering Screen (CPOL) for more information.

POSLOGX

PFPOSX

As needed

POSLOG for XLink

Generates and sends a custom POSLog to Xlink using the POSLOG XLink information in the cwdirectcp_interfaces.properties file.

PPT

PFPPT

As needed

Purge Printed Price Tags

Deletes records in the Price Tag Batch table that are in a P Printed status. The system also deletes the associated records in the Price Tag Work table. See Working with Price Tags (WPTG) for more information.

PRMOUPL

PRMOUPL

Create or Delete Promotions

Creates or updates promotions and related tables based on the information in the Promotion Upload table. See Promotion Upload for more information.

PSJD

ACR0321

Daily

Print Sales Journal by Division

Generates the Sales Journal by Division.

See Printing the Sales Journal (PDSJ).

PURGECS

PFR0137

The number of days old the sold to customer must be to be eligible for purge. The system uses the last change date to determine the age of the customer sold to record.

Daily

Purge Sold To Customers

Purges sold to customers that are older than the number of days specified.

If the Parameter is blank or 0, records must be 365 days old to be eligible for purge.

To be eligible for purge, the system verifies that:

• there are no open orders for the customer.

• there are no open refunds for the customer.

• there are no open returns for the customer.

• there is no open A/R for the customer.

• there are no open ticklers for the customer.

• there are no catalog requests for the customer.

• there are no open memberships for the customer.

See Purging Sold To Customers for background and for the list of tables that are purged.

PURGEOR

PFR0114

Set the parameter to Y in order to generate the Purged Order List; otherwise, the report is not generated.

Daily

Purge Orders

Purges orders that are closed or canceled, and that:

• have not had any activity for the Order Purge Days (C62) defined in the System Control table. For example, if the purge days is 365, a closed or canceled order will be eligible for purging if the order has not been entered, shipped, or maintained for one year. The system checks the Order Transaction History table for the most recent activity.

• do not have any pending returns or refunds.

• do not have any A/R open items in an open status.

See Purging Orders (MPOR) for background and for the list of order-related tables that are purged.

PURGEUA

PFR0125

The number of days old a User Audit or Password Audit record must be to be eligible for purge.

Daily

Purge User Audit Table

Purges User Audit and Password Audit records that are older than the number of days specified.

If the Parameter is blank or 0, records must be 365 days old to be eligible for purge.

See Tracking User and Password Updates for background.

PURGEUH

PFR0126

The number of days old a Upload History record must be to be eligible for purge.

Daily

Purge Upload History Table

Purges Upload History records that are older than the number of days specified in the Parameter field.

If the Parameter is blank or 0, records must be 21 days old to be eligible for purge. See Working with File Uploads (WUPL) for more information.

RESET

MSR0698

Run when a problem is detected

Note: Run this function only when you have a dedicated system; do not run this periodic function when the Billing Async is active, you are running pick slip generation or performing inventory transaction processing.

Daily Inventory Reset

• Resets the reserved quantity of items in inventory, as stored in the Item Warehouse table. The system uses the information in the Reserved Order Line table to determine the correct quantities of items reserved on open or held orders. See Reset Reserve Quantity (MRQR).

• Resets the backorder quantity of items in inventory, as stored in the Item Warehouse table. See Reset Backorder Quantity (MRBO).

• Resets the SKU open quantity, On hold quantity, and Quantity order direct ship in the SKU table based on the current open orders for the SKU. See Reset SKU Open Order Quantity (MRSO).

Note: You can use Reset Allocation Quantities (MRPC) to reset the printed quantities for orders, as stored in the Order Detail, Reserved Order Line and the Item Location tables. The system uses the information in the Pick Control Detail and the Pick Location tables to determine the correct quantities.

RESETOH

PFR0093

Run when a problem is detected.

Reset On Hand Quantity

Resets the quantity on-hand for each Item Warehouse record based on the total quantities on-hand for related Item Locations within the warehouse. See Reset Item Warehouse Quantity On Hand (MRIW).

Note: Run this function only when you have a dedicated system; do not run this periodic function when the Billing Async is active, you are running pick slip generation or performing inventory transaction processing.

REVERSE

PFR0133

Daily

Send Reversals for Expired Authorizations

Run this periodic function for a specified company to process all open Authorization History records that are eligible for authorization reversal processing.

When you run this periodic function, the system:

• Selects all open (Status is A or O) Authorization History records whose pay type is eligible for authorization reversal (the Send reversal field for the pay type is selected).

• For each record selected, the system calculates the age of the authorization by determining the elapsed days between the current date and the authorization date.

• If the elapsed days is equal to or greater than the Reauthorization days defined for the pay type, and the authorization service defined for the pay type allows authorization reversals (the Send reversal for the authorization service is selected), the system sends an authorization reversal request to the authorization service.

• The system creates an Authorization History Reversal record to indicate that the authorization reversal request was attempted. If the authorization service accepts the reversal request, the system updates the record with the date of the approval.

See Credit Card Authorization Reversal.

RFRECON

PFR0008

Monthly

Refund Reconciliation and Purge

Purges refund checks once you have reconciled or voided the checks. Generates the Check Reconciliation List.

See Reconciling Checks (MREC).

RLTITMF

PFR0101

Daily

Relate Item Feed

Sends item information to Relate. See Relate Item Feed.

RLTSLSF

PFR0102

Daily

Relate Sales Feed

Sends sales information to Relate. See Relate Sales Feed.

RSLTME

CSR0557

Daily

Release Order on Time Hold

Releases prepaid orders from hold automatically when the number of days to hold the order (in the Hold days field in the Pay Type table) has passed, and releases orders held for credit card authorization.

See Releasing Orders from Time Hold.

SCHDDEP

PFR0090

Positions 1-3: 3 position Authorization service code

Positions 4-10: 7 position Purchases transactions to generate

For example, where AUT is the authorization service code and 1234567 is the maximum number of deposits for purchases:

AUT1234567

Daily

Schedule Deposits

Submits the deposit processing job.

You can use the Parameter field to generate deposit transactions for a specific authorization service and/or define the maximum number of deposits to process for purchases.

Note: You can define a Purchases transactions to generate number in the Parameter field only if the Preload Deposits (L78) system control value is unselected.

If you do not define any parameters, the system uses the same settings as if you used the Auto Deposit Screen (Send or Receive Deposits) with all the default settings selected.

This function requires you to specify a company when you set up the periodic process.

Which job queue? If you are using the Paymentech Point-to-Point Integration and have defined a separate port number in the PMD_PAY_LINK_SERVICE_BATCH_DEPOSIT_PORT property setting to process batch deposit transactions, the system submits the AUTO_DEP job for the Paymentech transactions to the AUTODEP job queue, allowing you to run pick slip generation (batch authorizations) and deposits at the same time; otherwise, the system submits the AUTO_DEP job to the PICKGEN job queue, meaning you cannot run pick slip generation and deposits at the same time.

The AUTO_DEP job selects records from the Invoice Payment Method table for the service bureau(s) selected for deposit that have not yet been processed for deposit or credit, and whose deposit release date is the current date or earlier.

You can review the submitted AUTO_DEP job at the Job Management Screen. See Processing Deposits for more information.

SCVREV

PRF0077

Daily

Stored Value Card Reversal

Processes stored value card reversal trigger records (File type AHR) that are in a ready (R) status.

See Transmitting Activation and Reversal Transactions (SSVC).

SECRISK

PFR0087

Daily

Remove credit card data from closed or cancelled orders

Removes credit card numbers and expiration dates, deactivates pay types, and sets the Amount to charge to $.01 for closed or cancelled orders whose last order activity was older than the Credit Card Retention Days (K65) system control value.

SLSSMOT

PFSLSSUMOT

Date, in MMDDYY format

Daily

Sales Journal Summary by Order Type

Generates the Sales Journal Summary by Order Type for the date specified in the parameter. If no date is specified, generates the report for the previous date.

STOP_EC

ECX0243

Daily

Stop E-Commerce Async Jobs

Stops the E-Commerce Async jobs.

See Working with E-Commerce Job Control (EJCT).

STRASYN

MSSTRASYNC

Daily

Start Asyncs

If the asyncs are currently Inactive, this periodic function calls the Controlling Data Queue (CNTL_ASYNC) in Background Job Control (MBJC) and starts the background jobs.

This periodic function performs the same updates as selecting Start for the controlling data queue to start the background jobs.

See Starting the Background ASYNC Jobs.

STRIJCT

ILSTRGENER

The Process ID of the integration layer process you wish to start.

As needed

Start IJCT Process Passed

Starts the integration layer process whose Process ID is defined in the Parameter field.

Example: If you define ITEM_OUT in the Parameter field, this periodic function starts the ITEM_OUT integration layer process.

STRPMD

ILSTRPMD

Daily

Start PMD_ONLINE IJCT Job

Starts the PMD_ONLINE job in Working with Integration Layer Processes (IJCT). When started, the PMD_ONLINE job opens a connection to the online port used for the Paymentech Point-to-Point Integration.

ENDPMD

ILENDPMD

Daily

End PMD_ONLINE IJCT Job

Stops the PMD_ONLINE job in Working with Integration Layer Processes (IJCT). When stopped, the PMD_ONLINE job closes the connection to the online port used for the Paymentech Point-to-Point Integration.

STRT_EC

ECX0242

Daily

Start E-Commerce Async Jobs

Starts the E-Commerce Async jobs.

See Working with E-Commerce Job Control (EJCT).

SUSPEND

OER0756

Daily

Suspended Orders List

Generates the Suspended Orders List report, which provides a listing of all orders in a suspended status.

See Placing Suspended Stock (SUSP).

SVCACT

PFR0076

Daily

Stored Value Card Activation

Processes stored value card activation trigger records (File type SVC) that are in a ready (R) status.

See Transmitting Activation and Reversal Transactions (SSVC).

THRESHD

PFTHRESHMO

Daily

Threshold Monitor

• Updates all of the fields defined in the Order Control Summary table for the current transaction date.See Reviewing Operations Control Summary (FLSH).

• Updates the actual value fields and Last updated fields defined in the Threshold Values table.

• Monitors the threshold values to determine if a threshold has been breached.

• For each breached threshold that has an email address defined and whose Email interval is reached, generates a Threshold Monitor Breach email.

• Updates the actual value fields and Last updated fields defined in the Threshold Values table.

• Monitors the threshold values to determine if a threshold has been breached.

See Working with Threshold Values (WTHR).

Note: This periodic function performs updates similar to the ORDSUM periodic function.

TICKLER

PFR0072

Daily

Evaluate Create/Resolve Ticklers

Evaluates the:

• OO tickler event to determine if any open orders qualify for an OO event rule. Also, determines if any existing OO ticklers can be resolved. See OO (Aged Open Orders) Event Processing.

• UP tickler event to determine if any unconfirmed pick tickets qualify for a UP event rule. Also, determines if any existing UP ticklers can be resolved.See UP (Unconfirmed Pick Tickets) Event Processing.

• AR tickler event to determine if any existing AR ticklers can be created or resolved. See AR (Accounts Receivable) Event Processing.

• Next notification date for an existing open or in process tickler to determine if the system sends an email to the tickler supervisor notifying him of the aged tickler.

See Workflow Management Overview and Setup.

UPLSDTA

PFR0094

As needed

Supporting Data Upload

Creates supporting data records based on the information in the Supporting Data Upload table. Typically used as part of the integration with WinRetail. See Importing Item-Related Supporting Data (WinRetail Integration/SDUP) for more information.

UPLSETS

PFR0095

As needed

Set Component Upload

Creates set headers and components based on the information in the Set Component Upload table. Typically used as part of the integration with WinRetail. See Importing Set Components (WCUP) for more information.

URNCPN

PFR0021

Monthly

Unredeemed Coupon List

Generates the Outstanding Credits/Coupons Report, which lists all unredeemed records in the Coupon Redemption table, including gift certificates, coupons, merchandise credits, and bonus credits.

See Unredeemed Coupon Listing (PCPN).

UTSTSRP

UTSTSRPT

As needed

Managed Services Report

Generates the Managed Services report, used by MICROS staff to manage system processing.

WEEKCLR

MSR0575

Weekly

Weekly Clear

Clears week-to-date (WTD) fields in the SKU Offer Page table (INSKOP).

YEARCLR

MSR0577

Yearly

Clear Yearly Totals

Clears (zeros) yearly (YTD) buckets in tables such as Flash Report table (FLFLSH).

GLEXTRA

GLR0078

Weekly

GL Extract

Populates a general ledger download table, based on records in the General Ledger Interface table (GLINTR) that:

• are earlier than or equal to the date you run the periodic function, and

• have a blank Date posted, and

• are not in the Division to Exclude from General Ledger Download File (F68).

When the download is complete, the system updates the Date posted field in the General Ledger Interface table for each selected record.

The G/L Download Type (G03) system control value controls which general ledger download table the system populates.

See Generating the General Ledger Download Table (GGLD).

GLINVEN

PFR0099

Daily

Process G/L Inventory

Posts inventory updates to the general ledger. The periodic function:

• Looks at the GL Process Date field in the Item Transaction History table to determine which inventory updates to post to the general ledger. The function selects records whose GL Process Date is 0.

• Looks at the setting of the Capture General Ledger Detail (E71) system control value to determine whether to post inventory updates to the General Ledger Detail table.

• Uses the item transaction history date as the general ledger transaction date.

When completed, the function updates the GL Process Date field for the item transaction history records included in the general ledger postings to the current date. See Posting Changes to Inventory Value for an overview.

GLLIST

PFR0116

Daily

General Ledger List

Generates the Print General Ledger Interface Report for the prior date.

If any activity created an out-of-balance General Ledger entry:

• Generates a Serenade Support Notification to the email addresses specified in the Support_Emails setting in the cwdirectcp_email.properties file.

• Logs the out-of-balance condition to the Alert Log.

PURGEGL

PFR0123

As needed

G/L Detail Purge

Purges records in the General Ledger Detail table based on the setting of the G/L Detail Purge Days (M17) system control value.

MEMBER

PFR0036

Daily

Generate Membership Orders

Generates orders for all standard customer memberships.

See Generating Membership Orders (EGMO).

OPENPP

PFR0006

Monthly

Open Prepaid Orders List

Generates the Open Prepaid Order List.

REFCCCR

PFR0115

Daily

Process Credit Card Credit Refunds

Process credit card credits with no limit on the amount to generate. The system generates a Credit Card Credit Register that identifies the amount, customer name, and order number of each credit processed. The system also produces either a Credit Card Credit Acknowledgment (if the Print Credit Card Credit Acknowledgments (C35) system control value is selected) or an email notification when the Credit Card Credit Acknowledgement E-Mail Program (H08) is set to CCCNOTF, (regardless of the setting of the Print Credit Card Credit Acknowledgments (C35) value) for each credit as appropriate; see When Does the System Generate an Email Notification?

See Processing Refunds (MREF) for processing information.

REFDUET

CSR0986

Monthly

Refund Due List by Type

Generates the Refund Due List by Type.

See Printing and Interpreting Refund Due Lists (MRDU).

REFPROC

CSR0533

Monthly

Refunds Processed

Generates the Processed Refund Register.

See Printing the Processed Refund Register (PPRR).

REFSVCR

PFR0118

Daily

Process SVC Credit Refunds

Process stored value card credits with no limit on the amount to generate. The system issues a new stored value card to the sold to customer for the refund amount. The system also:

• Produces the Stored Value Card Credit Register.

• Writes an order transaction history message: F Stored Value Card refund created.

• Adds the stored value card item defined in the Default SVC Refund Item Number (I73) system control value to the order at no charge and performs pick slip preparation. Note: The system will not generate a stored value card refund unless the stored value card refund item has available inventory. If the item does not have available inventory, the stored value card refund remains unprocessed.

• Generates a pick slip for the stored value card item if the Default Pick Generation Template for SVC Refund Processing (I75) system control value indicates a pick slip generation template.

You can then follow the normal process of activating, billing, and shipping the stored value card to the customer.

See Generating Stored Value Card Refunds for an overview.

REFWRO

PFR0009

Monthly

Refunds Written Off

Writes off refunds and generates the Refund/Write Offs - Refund Checks report.

See Working with Refunds, Writeoffs and Balances Due (WREF).

RSTCONO

CSRSTONORD

Run when a problem is detected

Reset Customer Sold To $ On Order

Resets the On order amount field in the Customer Sold To Order History table so that it matches the amount of any existing open orders for the customer. See Resetting Customer Sold To $ On Order (RONO).

Note: End all background async jobs so that the On order amount is not changed while the reset job recalculates the On order amount.

UNACTSV

PFR0075

Daily

Unactivated Stored Value Cards

Generates the Unactivated Stored Value Card Report. You can use this report to review any stored value cards that require attention because:

• the stored value card was declined by the service bureau for activation

• the stored value card was billed at the manifest station without a number assignment

See Stored Value Card Purchase and Activation.

UNGIFT

PFR0007

Monthly

Unredeemed Gift Certificates

Generates the Unredeemed Gift Certificate List.

See Working with Gift Certificates.

EMAILUD

PFR0089

Daily

Customer Email Status Updates

Matches a record in the Customer Email Updates Table to a sold to customer and, if an exact match is found, updates the sold to customer’s Opt in/opt out field with the Email Status defined for the customer email updates record. Generates the Unmatched Email Status Report, which lists records in the Customer Email Updates table that were not matched to a sold to customer. See Receiving Customer Email Status Updates From an External System for an overview and the required setup.

ECAVAIL

ECR0144

Daily

Download E-Commerce Item Availability

Extracts the current available quantity for items and SKUs that you have previously downloaded to the e-commerce staging library.

The system downloads the current availability information for items only if you have used the Downloading E-Commerce Offer Tables (EOFR) menu option to extract these items to the EC Item table (EXITEM).

When you use the Download E-Commerce Offer Tables (EOFR) menu option, the system writes a record for all related offer, items, and SKUs in the E-Commerce Item Extract table (ECITEX) and the E-Commerce SKU Extract table (ECSKEX). When you run the ECAVAIL periodic function, the system checks these tables to determine whether to include an item or SKU in the availability download.

See E-Commerce Item Availability Processing.

ECCSTEX

ECX0358

Monthly

Download CST Extended Changes

Extracts updated customer user fields to the EC Customer Extended (EXCSTE) staging table.

Selects customer records that are:

• active, based on the setting of the Inactive field for the customer

• newly created, if they include user information

• updated, if the update includes a change, addition, or deletion of any of the user fields

• deleted, if the deleted customer included user field information.

• Does not select customers whose Inactive field changes from inactive to active or from active to inactive.

See Extracting Customer Changes through a Periodic Function.

ECGFTC

ECR0142

Daily

Download Gift Certificates and Coupons

Extracts information on open, unredeemed coupons and gift certificates from the Coupon Redemption table (CSCPNR) to the EC Gift Certificate table (EXGFTC).

ECITMCH

ECX0178

Daily

Download Item Changes

Extracts item changes to the EC Item table and SKU changes to the EC Sku table for items and SKUs previously downloaded to e-commerce using the Downloading E-Commerce Offer Tables (EOFR) menu option.

Additionally, extracts items whose item ship via overrides have been updated since the last time the item was downloaded to e-commerce to the EC Item Ship Via Override Download table.

ECOMINV

ECR0389

Daily

E-Commerce Item XRef All Items

Downloads all items that contain a long SKU style number to the EC SKU Retail XRef table and EComm SKU Extract table.

ECOMNEW

ECR0390

Daily

E-Commerce Item XRef New Items

Downloads new items that contain a long SKU style number to the EC SKU Retail XRef table and EComm SKU Extract table.

ECGFTCH

ECR0302

Daily

Download Gift Certificates

Extracts information on open, unredeemed gift certificates from the Coupon Redemption table (CSCPNR) to the EC Gift Certificate table (EXGFTC).

ECSHCNF

ECR0154

Daily

Shipment Confirmation Emails

Sends shipment confirmation emails.

See Sending Internet Order Ship Confirmation (ESCF).

Description of the pick slip generation template you wish to run

PFR0107

The Description of the pick slip generation template you wish to run.

Note: The Parameter must match the Description defined for the pick slip generation template. For example, if the description of the pick slip generation template is ORDER #, the parameter must also be ORDER # and not ORDER#.

Daily

Scheduled Pick Slip Generation

Runs pick slip generation using the pick slip generation template specified in the Parameter field. See Scheduling Pick Slip Generation for more information.

BTCHPOL

PFBPOL

The Warehouse number for which you wish to run Batch PO Layering. Must be a valid Warehouse code in the Warehouse table.

If you enter 0 or an invalid warehouse code, the system runs the function, but it immediately ends without making any updates.

As needed

Batch PO Layering

Runs Batch Purchase Order Layering to update the expected delivery dates for items on backorder based on recreated records in the PO Layering table. The system recreates the records in the PO Layering table based on the quantity and expected delivery dates for items on open purchase orders. The system performs Batch PO Layering for the warehouse defined in the Parameter field. See Purchase Order Layering for an overview and the updates that are performed.

Note: It is important to run this function before you generate backorder notices or run any other function that relies on accurate purchase order date and quantity information.

CARRYOV

PFR0033

Carryover Report

Prints the Carryover Report.

See Printing the Carryover Report (PCOR).

LOBSTAT

PFR0034

Daily

Reset Line of Business Stats

Updates line of business order queue statistics.

See Updating the Line of Business Order Queue Statistics.

RESRVBO

FLR0804

Daily

Reserve Backorders

Evaluates backorders by searching for any item warehouse that has a backorder quantity greater than 1 and whose on-hand quantity - reserved quantity is greater than 0. Will try to reserve the order detail line (as long as a cancel date does not exist). See Working with the EBO_ASYNC Job.

If an order line on backorder is reserved, the system removes any pick slip preparation from the order and then reevaluates the order for pick slip preparation; see Preparing Orders for Pick Slip Generation.

RSTPICK

PFR0111

As needed

Reset Pick Control

Resets the printed quantities for orders, as stored in the Order Detail, Reserved Order Line and the Item Location tables. The system uses the information in the Pick Control Detail and the Pick Location tables to determine the correct quantities. You can also perform the same updates using the Reset Allocation Quantities (MRPC) menu option.

STRCDC

ILStrCDC

Daily

Start CDC Job in WPBJ

Starts the CDC Async job used to process transactions between CWCollaborate or Locate’s Drop Ship Manager and CWSerenade in the CWCollaborate or Locate Drop Ship Integrations.

ENDCDC

ILEndCDC

Daily

End CDC Job in WPBJ

Ends the CDC Async job used to process transactions between CWCollaborate or Locate’s Drop Ship Manager and CWSerenade in the CWCollaborate or Locate Drop Ship Integrations.

PACKPRG

FLPCKPRG

Monthly

Purge Packer Statistics

Purges records in the Packer Productivity table based on the setting of the Packer Productivity Purge Days (K33) system control value.

PURGPCL

PFR0091

Weekly

Purge Unused Pick Control Labels

Submits the PURGPCL job, which:

• Purges all unused Pick Control Label records prior to the date you entered in the Unused Pick Label Purge Days (K83) system control value that are not associated with an outstanding pick slip. The system checks the Pick Control Header table to verify that an outstanding pick slip does not exist for the Pick Control Label record.

• Purges the associated records in the Pick Out table.

BILLUPD

PFR0100

Daily

Delay Billing Updates

Submits the BILLUPD job, which processes deferred billing updates for records in the Invoice Header table whose Process Date field is 0.

You must run the Delay Billing Updates Process if you select the Delay Billing Updates (K85) system control value; see this system control value for more information. Also, see Batch Billing Updates for a table that lists the billing updates that are deferred until you run the Delay Billing Updates Process.

Note: You can also submit the Delay Billing Updates Process using the BILL_UPD Billing Updates integration layer job. When this job is active, at defined intervals the job processes deferred billing updates for records in the Invoice Header table whose Process Date field is 0. The Outbound delay time defined for the BILL_UPD integration layer job defines how often the job processes the deferred billing updates. Example: If the Outbound delay time is 60, the system looks for deferred billing updates to process every 60 seconds.

PICKRFH

PFR0103

Daily

Pick Gen Refresh

Submits a process that evaluates orders for pick slip preparation, and if eligible:

1. Removes any pick slip preparation that may have already occurred for the order; see Removing Pick Slip Preparation from an Order for the updates that are performed.

2. Applies pick slip preparation to the order; see Applying Pick Slip Preparation to an Order for the updates that are performed.

See Batch Pick Slip Preparation for additional details.

ARBATCH_IN: Receives batch A/R payments against open items.

STRARIN

ILStrARIn

ENDARIN

ILEndARIn

BILL_UPD: Processes deferred billing updates for records in the Invoice Header table whose Process Date field is 0. The Outbound delay time defines how often, in seconds, the job processes the deferred billing updates.

STRBILL

ILRSTRBILLUPD

ENDBILL

ILRENDBILLUPD

BROKER: Generates Order Broker requests, inquiry requests, and update (cancel requests, and receives responses.

STRBROK

ILSTRBROKR

ENDBROK

ILENDBROKR

CCAUTH_BTH: Sends and receives batch authorizations for credit cards, debit cards, and stored value cards to the service bureau via CWIntegrate.

STRBAUT

ILSTRCCBTH

ENDBAUT

ILENDCCBTH

CCAUTH_ONL: Sends and receives online authorizations for credit cards, debit cards, and stored value cards to the service bureau via CWIntegrate.

STRONLI

ILSTRCCONL

ENDONLI

ILENDCCONL

DEPOSITS: Sends and receives batch deposits for credit cards, debit cards, and stored value cards to the service bureau via CWIntegrate.

STRCCDP

ILSTRDEPST

ENDCCDP

ILENDDEPST

CUST_OUT: Generates an outbound message for each customer that you create, change, or delete.

STRCSTD

LSTRCSTOT

ENDCSTD

ILENDCSTOT

CUST_SRCH: Receives a request for information on one or more customers matching specific search criteria, and generates a response.

STRCSRC

ILSTRCSTSR

ENDCSRC

ILENDCSTSR

CUST_HIST: Receives a request for customer order history or information on a specific order, and generates a response.

STRCHST

ILSTRCSTHT

ENDCHST

ILENDCSTHT

CUSTOMER_IN: Receives a new customer or change to an existing customer.

STRCSIN

ILSTRCSTIN

ENDCSIN

ILENDCSTIN

EMAIL: Receives email messages and creates Correspondence History and Correspondence History Detail records.

STREML

ILSTREMLIN

ENDEML

ILENDEMLIN

FDMS_BATCH: Sends and receives batch authorization transactions between CWSerenade and the FDMS service bureau.

FDMSBS

ILSTRFDMSB

FDMSBE

ILENDFDMSB

FDMS_DEP: Sends and receives deposit transactions between CWSerenade and the FDMS service bureau.

FDMSDS

ILSTRFDMSD

FDMSDE

ILENDFDMSD

FDMSONAUTH: Sends and receives online transactions between CWSerenade and the FDMS service bureau.

FDMSONS

ILSTRFDMSO

FDMSONE

ILENDFDMSO

FDMS_BALANCE: Sends and receives balance inquiry transactions between CWSerenade and the FDMS service bureau.

SVCBALS

ILSTRSVCBL

SVCBALE

ILENDSVCBL

INV_INQURY: Receives a request for inventory availability on a specific item/SKU and generates a response.

STINVIQ

ILSTRINVIQ

ENINVIQ

ILENDINVIQ

INV_DOWNLD: Sends inventory availability information to another system.

STRINVD

ILSTRINVDN

ENDINVD

ILENDINVDN

INVOIC_OUT: Sends invoice information to another system.

STRINVO

ILSTRINVOT

ENDINVO

ILENDINVOT

INVTRAN_IN: Receives inventory transactions and updates inventory information, such as in the Item Location and Item Warehouse tables.

STRITRN

ILSTRINVIN

ENDITRN

ILENDINVIN

ITEM_OUT: Sends item and SKU information to another system.

STRITEM

ILSTRITMOT

ENDITEM

ILENDITMOT

ORDER_IN: Receives new orders through a generic order interface and optionally generates detailed or simple acknowledgements, as indicated by the inbound order message.

STRORDR

ILSTRORDIN

ENDORDR

ILENDORDIN

PICK_OUT: Sends a pick slip message for each generated or voided pick slip.

STRPICK

ILStrPickO

ENDPICK

ILEndPickO

PO_OUT: Sends purchase order information to an external system.

STRPOOU

ILStrPOOut

ENDPOOU

ILEndPOOut

RETURN_IN: Receives a request to process a return, and generates a response indicating whether the return processed correctly.

STRRTIN

ILStrRtnIn

ENDRTIN

ILEndRtnIn

RETURN_OUT: Sends customer return information to an external system.

STRRTO

ILStrRtOut

ENDRTO

ILEndRtOut

SVC_AUTH: Sends batch stored value card authorization requests to the service bureau via CWIntegrate and receives responses.

STRSVB

ILStrSVCAu

ENDSVB

ILEndSVCAu

SVC_AUTHOL: Sends online stored value card authorization requests to the service bureau via CWIntegrate and receives responses.

STRSVO

ILStrSVCAO

ENDSVO

ILEndSVCAO

SVC_DEP: Sends stored value card deposit requests to the service bureau via CWIntegrate and receives responses.

STRSVD

ILStrSVCDp

ENDSVD

ILEndSVCDp

SVC_OUT: Sends stored value card activation requests to the service bureau via CWIntegrate and receives responses.

STRSVA

ILStrSVCOt

ENDSVA

ILEndSVCOt

SVC_REVRSL: Sends stored value card reversal transactions to the service bureau via CWIntegrate and receives responses.

STRSVR

ILStrSVCRv

ENDSVR

ILEndSVCRv

VENDOR_OUT: Sends vendor information to another system.

STRVEND

ILSTRVNDOT

ENDVEND

ILENDVNDOT

WORKFLOW: Receives new workflow events to create ticklers.

STRWRKF

ILStrWrkFl

ENDWRKF

ILEndWrkFl

XMLFILE: Reads files containing XML messages that are waiting to be processed.

STRXMLF

ILSTRXML

ENDXMLF

ILENDXML

CAINV

PFCAINV

As needed

ChannelAdvisor Inventory Upload

Generates a file of current inventory levels for FTP to ChannelAdvisor. See Sending Current Inventory Information to ChannelAdvisor for an overview.

CAORDUP

PFCAOUP

As needed

ChannelAdvisor Order Upload

Sends ChannelAdvisor a request for new orders and creates orders based on the information in the order response message. See Importing Orders from ChannelAdvisor for an overview.

CAPRICE

PFCAPRICE

ChannelAdvisor Price Upload

Generates a file of current pricing for items sold through the ChannelAdvisor integration. See Sending Current Prices to ChannelAdvisor for an overview.

CASHIP

PFCASHIP

As needed

ChannelAdvisor Ship Confirmation Upload

Sends shipment confirmation messages to Channel Advisor. See Sending Shipment Confirmations to ChannelAdvisor for an overview.

CPGIXUP

PFRCPGEXUP

Daily

Customer Price Group SKU Exclusion Upload

Submits the Customer Price Group SKU Exclusion Upload Process to upload customer price group item exclusion information from an external system to create, update, or delete records in the Customer Price Group SKU Exclusion table. See Customer Price Group SKU Exclusion Upload for an overview.

CSTDWNL

PFRCSTDNLD

Daily

Mass Customer Download

Generates a batch file that contains a Mass Customer Download XML Message (CWCustomerDownload) for each sold to customer whose customer class matches the customer class defined in the MASS_CUSTDWNLD_CUSTOMER_

CLASSES setting in Working with Customer Properties (PROP).

See Mass Customer Download for more information.

CYBDMUP

PFCYBDMUP

Daily

Cybersource Decision Manager Update

Run this periodic function to receive the Fraud Decision assigned to orders that received a REVIEW Cybersource Decision Manager Fraud Score response during online authorization processing. Based on the Fraud Decision received from Cybersource, the system:

• If the Fraud Decision assigned to the order is ACCEPT, releases the order from FS Fraud Scoring Hold.

• If the Fraud Decision assigned to the order is REJECT, and no part of the order has been shipped, cancel the order using the cancel reason code in the Fraud Score Cancel Reason Code (M14) system control value. If the entire order cannot be cancelled, place the order on FC Fraud Cancellation Hold.

The system writes an order transaction history message noting the response received from Cybersource Decision Manager. Any review comments returned from Cybersource are stored on the order as an order message. See Cybersource Decision Manager Fraud Scoring for additional information.

IHDWOIT

PFR0106

As needed

Invoice Download Comparison

Matches invoices created for the previous day to records in the IL Trigger table with a record type of IHD. If an invoice exists without a corresponding IHD trigger, the system creates an Add IHD trigger record and writes a message similar to the following in the Trace log: Periodic Function IHDWOIT may have created a IHD WOIT Transaction for Company#:7 Order # : 2844 Invoice #: 573.

See Generic Invoice Download API for an overview on the Invoice Download process and the required setup.

IMPSTLC

PFR0122

• Position 1 = Set to Y or y if the store cross-reference records should be created with the Ship to store flag selected; otherwise, you would typically set the first position to N.

• positions 2-11 = The code identifying the system associated with the locations. Must be a valid system code in Locate.

Example: If the parameter is set to NPOS, the periodic function imports location records for system POS in Locate, and leaves the Ship to store flag for each imported location unselected.

As needed

Import Store Cross Reference Locations through Locate’s Discovery Web Service

Uses Locate’s discovery web service to request information on all existing location associated with a specified system in Locate, and create Store Cross Reference records for locations if they do not already exist.

For more information: See Importing Store Cross Reference Locations through Locate’s Discovery Web Service.

INVDWNL

ILR0081

Weekly

Inventory Download

Creates inventory download triggers (File type ITW) for an item/SKU if:

• the Create Generic Inventory Download Trigger Records (I32) system control value is selected.

• the record matches the trigger rules for the INV_DOWNLD process in Integration Layer Job Control (IJCT).

• there is at least one Item Warehouse record that matches all criteria.

See Generic Inventory Download API.

PCUPLD

PFPRCCODUP

Daily

Price Code Upload

Submits the Price Code Upload Process to upload price code information from an external system to create, update, or delete records in the Price Code, Price Code Customer, and Price Code Details tables. See Price Code Upload for an overview.

PURGIJT

ILR0026

Weekly

Purge IJCT Trigger Records

Purges IL Outbound Trigger records older than the number of days specified in the Outbound Interface Trigger File Purge Days (I14) system control value, using the following calculation: Last processed date is less than the current system date by the number of purge days and Status is X.

RIPRCUP

PFRRIPRCUP

Daily

Pricing Upload

Submits the Pricing Upload Process to upload records from the Pricing Upload table to the Special Pricing by Source table and QPM Detail table. See Pricing Upload Interface for an overview.

RLTCSUP

PFRBCC

As needed

Customer Upload to Relate

Sends all CWSerenade sold to customers, excluding any sold to customers whose Ghost field in the Customer Sold To table is Y, to Relate using the batch Relate Add or Update Customer Message. See Relate Batch Customer Conversion.

RLTCSID

PFRCIU

As needed

Update Customer with Relate ID

Updates the Relate ID in the Customer Sold To table with the Customer ID from Relate. See Relate Batch Customer Conversion.

RLTNOID

PFRCNI

After running RLTCSID

Report Customer with No Relate ID

Generates a report listing the CWSerenade sold to customers that do not have a Relate ID. See Relate Batch Customer Conversion.

SLSUPLD

PFR0109

Daily

Upload Salesman Associates

Submits the Salesman Associate Upload Process to upload salesman information from an external system to create or update records in the Salesman table. See Salesman Associate Upload for an overview and the required setup.

STRUPLD

PFR0110

Daily

Upload Stores

Submits the Store Upload Process to upload store information from an external system to create or update records in the Store Cross Reference table. See Store Upload for an overview and the required setup.

SYNCRDB

PFR0105

As needed

Synchronize Remote Customers

Submits unsynchronized customers to Relate, using the Synchronize with remote DB field in the Customer Sold To table as a trigger. You would use this periodic function to support the interactive customer integration with Relate. See Synchronizing Customer Information through a Periodic Function for more information.

CLROH99

PFRCLROH99

As needed

Clear On Hand for Division 99

Allows you to clear the on-hand inventory for each warehouse whose Division is 99. The system clears the on-hand quantity for the warehouse in the Item Warehouse table and Item Location table.

FGUPDT

PHR0049

Monthly

Note: Do not run this periodic function when Asyncs are active.

Update Cost of Finished Goods

• Updates the cost of a finished good when the cost of one or more of its component items changes and generates the Finished Good Items Average or Standard Cost Updated Report. See Updating the Cost of a Finished Good.

• Updates the General Ledger Interface table with the change in inventory valuation.

• Creates an item download trigger. See Generic Item Download API.

Note: If a component item changes and you do not run this periodic function, the finished good item cost will not be accurate and reports will not be correct.

PFR0063

PFR0063

Daily

Drop Ship On Hold Report

Generates the Drop Ship Integration Items on Hold from Vendor report.

See Printing Drop Ship Reports (PDSR).

PFR0064

PFR0064

Daily

Drop Ship Revised Due Date Report

Generates the Drop Ship Integration Items with Revised Due Date report.

See Printing Drop Ship Reports (PDSR).

PFR0065

PFR0065

Daily

Drop Ship Pending Cancel Report

Generates the Drop Ship Integration Items Pending Cancellation report.

See Printing Drop Ship Reports (PDSR).

PORST

OER1018

As needed

PO Reset

Resets the open PO quantities in the Item Warehouse table based on purchase order detail lines that are open or held, or received into suspense or into a pending putaway warehouse location.

POUPLD

PFR0085

As needed

Purchase Order Upload

Submits the purchase order upload process.

See PO Upload Interface.

RIUPLD

PFR0084

As needed

Retail Integration Item Upload

Submits the retail integration item upload process.

Once completed, if the Create Generic Item Download Trigger Records (I15) or Use Data Warehouse (G94) system control values are selected, the system submits the secondary job RISECU to create item download triggers and data warehouse capture transactions.

See Working with Retail Integration Item Upload (RIIU) and RI Item Upload Process.

UPD_STD

POR0461

Monthly

Note: Do not run this periodic function when Asyncs are active.

Update Standard Cost

Updates the cost of all items in the SKU table with the item’s landed cost. The system uses the price defined for the primary vendor plus any additional vendor/item charges to determine the landed cost.

The system only updates the standard cost for items with a primary vendor and a vendor item associated with the vendor.

The Costing Method (A25) system control value must be set to STANDARD in order to update the standard cost of all items.

See Updating Standard Cost (MSCC).

VNDUPLD

PFR0086

As needed

Vendor Upload

Submits the vendor upload process.

See Working with Vendor Upload (LVUP).

PSTRCPT

PFR0104

As needed

Purge Store Transfer Receipts

Purges records in the Store Transfer Receipt table (INSTXR) whose Process status is X Closed and whose Process date is older than 30 days. See Processing Store Transfer Receipts.

PURGEPR

PFR0112

The number of days from the promotion end date that a completed promotion will be eligible for purge.

Example:

promo1 end date = 1/15/12

promo2 end date = 3/18/12

purge days = 15

If you run this periodic function on 3/20/12, the system deletes any promotion with an end date less than 3/5/12. In this example, the system deletes promo1 and retains promo2.

As needed

Purge Promotions

When you run this periodic function, the system uses the current date - the purge days parameter to determine the promotions to purge. Any promotions whose end date is equal to or earlier than the calculated purge date will be purged. If the Parameter is set to 0, the system does not purge any promotions. The system purges promotions from the following tables:

• Promotion

• Promotion Discount

• Promotion Customer

• Promotion Item Exclusion

• Promotion BOGO

• Promotion Item Category

• Promotion Source

• Promotion BOGO by Price Code

SUMVIA

OER1024

Daily

Update Ship Via/Item Summary

Runs a batch job to collect information on the current number of available order lines for each item/ship via combination in your company and populates the Ship Via Item Summary Header (OESVIH) table and Ship Via Item Summary Detail (OESVID) table. You can review the total open orders, shippable units, and oldest arrival dates for each item with a particular ship via assigned using the Ship Via/Item Inquiry (SVII) menu option.

WUDWNLD

PFR0043

Daily

Western Union Download

Downloads order information to the Western Union Download table. The system downloads any orders that contain the check interface pay type and have a blank check interface download date. The Western Union Download table allows you to send check information to an outside service for verification.

See Check Interface Payment Type (G26).

RECURPO

PFR0031

Monthly

Process Recurring Purchase Orders

Generates recurring purchase orders. You can use the Recurring Purchase Order Screen to create a recurring PO template.

You can review the recurring POs generates at the Recurring Purchase Orders Generated Screen (Displaying).

The PO Allow Recurring (A50) system control value must be selected.